[dbo].[asi_GetAccessArea]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_GetAccessArea

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@navmarker	varchar(36)	36
@pageset	varchar(36)	36

SQL Script

/****** Object:  Stored Procedure dbo.asi_GetAccessArea    Script Date: 7/3/2003 4:58:03 PM ******/
CREATE PROCEDURE dbo.asi_GetAccessArea
    @navmarker varchar(36),
    @pageset varchar(36) = null
AS

select AccessAreaKey
from NavigationMain
where Marker = @navmarker
and PageSet = ISNULL(@pageset, ' ')

GO

Uses

[dbo].[NavigationMain]
dbo